﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DsClaims" targetNamespace="http://tempuri.org/DsClaims.xsd" xmlns:mstns="http://tempuri.org/DsClaims.xsd" xmlns="http://tempuri.org/DsClaims.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="RundConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="RundConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.OasisIBS.My.MySettings.GlobalReference.Default.RundConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClaimsTableAdapter" GeneratorDataComponentClassName="ClaimsTableAdapter" Name="Claims" UserDataComponentName="ClaimsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RundConnectionString (MySettings)" DbObjectName="Rund.dbo.Claims" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Claims] WHERE (([SNo] = @Original_SNo) AND ((@IsNull_ClientNo = 1 AND [ClientNo] IS NULL) OR ([ClientNo] = @Original_ClientNo)) AND ((@IsNull_ClientName = 1 AND [ClientName] IS NULL) OR ([ClientName] = @Original_ClientName)) AND ((@IsNull_PolicyNo = 1 AND [PolicyNo] IS NULL) OR ([PolicyNo] = @Original_PolicyNo)) AND ((@IsNull_ClaimNo = 1 AND [ClaimNo] IS NULL) OR ([ClaimNo] = @Original_ClaimNo)) AND ((@IsNull_DateLose = 1 AND [DateLose] IS NULL) OR ([DateLose] = @Original_DateLose)) AND ((@IsNull_DateReported = 1 AND [DateReported] IS NULL) OR ([DateReported] = @Original_DateReported)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_DateClosed = 1 AND [DateClosed] IS NULL) OR ([DateClosed] = @Original_DateClosed)) AND ((@IsNull_AmountPaid = 1 AND [AmountPaid] IS NULL) OR ([AmountPaid] = @Original_AmountPaid)) AND ((@IsNull_CheqNo = 1 AND [CheqNo] IS NULL) OR ([CheqNo] = @Original_CheqNo)) AND ((@IsNull_TransDate = 1 AND [TransDate] IS NULL) OR ([TransDate] = @Original_TransDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ClientNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ClientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PolicyNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PolicyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClaimNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClaimNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ClaimNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClaimNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateLose" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateLose" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateLose" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateLose" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateReported" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateReported" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateReported" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReported" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateClosed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateClosed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateClosed" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateClosed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AmountPaid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AmountPaid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_AmountPaid" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="AmountPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CheqNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CheqNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CheqNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CheqNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Claims] ([ClientNo], [ClientName], [PolicyNo], [ClaimNo], [DateLose], [DateReported], [Status], [DateClosed], [AmountPaid], [CheqNo], [TransDate]) VALUES (@ClientNo, @ClientName, @PolicyNo, @ClaimNo, @DateLose, @DateReported, @Status, @DateClosed, @AmountPaid, @CheqNo, @TransDate);
SELECT SNo, ClientNo, ClientName, PolicyNo, ClaimNo, DateLose, DateReported, Status, DateClosed, AmountPaid, CheqNo, TransDate FROM Claims WHERE (SNo = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ClientNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ClientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PolicyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ClaimNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClaimNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateLose" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateLose" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateReported" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReported" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateClosed" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateClosed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@AmountPaid" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="AmountPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CheqNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CheqNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SNo, ClientNo, ClientName, PolicyNo, ClaimNo, DateLose, DateReported, Status, DateClosed, AmountPaid, CheqNo, TransDate FROM dbo.Claims</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Claims] SET [ClientNo] = @ClientNo, [ClientName] = @ClientName, [PolicyNo] = @PolicyNo, [ClaimNo] = @ClaimNo, [DateLose] = @DateLose, [DateReported] = @DateReported, [Status] = @Status, [DateClosed] = @DateClosed, [AmountPaid] = @AmountPaid, [CheqNo] = @CheqNo, [TransDate] = @TransDate WHERE (([SNo] = @Original_SNo) AND ((@IsNull_ClientNo = 1 AND [ClientNo] IS NULL) OR ([ClientNo] = @Original_ClientNo)) AND ((@IsNull_ClientName = 1 AND [ClientName] IS NULL) OR ([ClientName] = @Original_ClientName)) AND ((@IsNull_PolicyNo = 1 AND [PolicyNo] IS NULL) OR ([PolicyNo] = @Original_PolicyNo)) AND ((@IsNull_ClaimNo = 1 AND [ClaimNo] IS NULL) OR ([ClaimNo] = @Original_ClaimNo)) AND ((@IsNull_DateLose = 1 AND [DateLose] IS NULL) OR ([DateLose] = @Original_DateLose)) AND ((@IsNull_DateReported = 1 AND [DateReported] IS NULL) OR ([DateReported] = @Original_DateReported)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_DateClosed = 1 AND [DateClosed] IS NULL) OR ([DateClosed] = @Original_DateClosed)) AND ((@IsNull_AmountPaid = 1 AND [AmountPaid] IS NULL) OR ([AmountPaid] = @Original_AmountPaid)) AND ((@IsNull_CheqNo = 1 AND [CheqNo] IS NULL) OR ([CheqNo] = @Original_CheqNo)) AND ((@IsNull_TransDate = 1 AND [TransDate] IS NULL) OR ([TransDate] = @Original_TransDate)));
SELECT SNo, ClientNo, ClientName, PolicyNo, ClaimNo, DateLose, DateReported, Status, DateClosed, AmountPaid, CheqNo, TransDate FROM Claims WHERE (SNo = @SNo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ClientNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ClientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PolicyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ClaimNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClaimNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateLose" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateLose" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateReported" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReported" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateClosed" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateClosed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@AmountPaid" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="AmountPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CheqNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CheqNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ClientNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ClientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PolicyNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PolicyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClaimNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClaimNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ClaimNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClaimNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateLose" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateLose" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateLose" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateLose" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateReported" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateReported" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateReported" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReported" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateClosed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateClosed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateClosed" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateClosed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AmountPaid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AmountPaid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_AmountPaid" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="AmountPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CheqNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CheqNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CheqNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CheqNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SNo" ColumnName="SNo" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SNo" DataSetColumn="SNo" />
              <Mapping SourceColumn="ClientNo" DataSetColumn="ClientNo" />
              <Mapping SourceColumn="ClientName" DataSetColumn="ClientName" />
              <Mapping SourceColumn="PolicyNo" DataSetColumn="PolicyNo" />
              <Mapping SourceColumn="ClaimNo" DataSetColumn="ClaimNo" />
              <Mapping SourceColumn="DateLose" DataSetColumn="DateLose" />
              <Mapping SourceColumn="DateReported" DataSetColumn="DateReported" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="DateClosed" DataSetColumn="DateClosed" />
              <Mapping SourceColumn="AmountPaid" DataSetColumn="AmountPaid" />
              <Mapping SourceColumn="CheqNo" DataSetColumn="CheqNo" />
              <Mapping SourceColumn="TransDate" DataSetColumn="TransDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DsClaims" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DsClaims" msprop:Generator_UserDSName="DsClaims">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Claims" msprop:Generator_UserTableName="Claims" msprop:Generator_RowEvArgName="ClaimsRowChangeEvent" msprop:Generator_TableVarName="tableClaims" msprop:Generator_TablePropName="Claims" msprop:Generator_RowDeletingName="ClaimsRowDeleting" msprop:Generator_RowChangingName="ClaimsRowChanging" msprop:Generator_RowDeletedName="ClaimsRowDeleted" msprop:Generator_RowEvHandlerName="ClaimsRowChangeEventHandler" msprop:Generator_RowChangedName="ClaimsRowChanged" msprop:Generator_TableClassName="ClaimsDataTable" msprop:Generator_RowClassName="ClaimsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SNo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSNo" msprop:Generator_ColumnPropNameInRow="SNo" msprop:Generator_ColumnPropNameInTable="SNoColumn" msprop:Generator_UserColumnName="SNo" type="xs:long" />
              <xs:element name="ClientNo" msprop:Generator_ColumnVarNameInTable="columnClientNo" msprop:Generator_ColumnPropNameInRow="ClientNo" msprop:Generator_ColumnPropNameInTable="ClientNoColumn" msprop:Generator_UserColumnName="ClientNo" type="xs:long" minOccurs="0" />
              <xs:element name="ClientName" msprop:Generator_ColumnVarNameInTable="columnClientName" msprop:Generator_ColumnPropNameInRow="ClientName" msprop:Generator_ColumnPropNameInTable="ClientNameColumn" msprop:Generator_UserColumnName="ClientName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PolicyNo" msprop:Generator_ColumnVarNameInTable="columnPolicyNo" msprop:Generator_ColumnPropNameInRow="PolicyNo" msprop:Generator_ColumnPropNameInTable="PolicyNoColumn" msprop:Generator_UserColumnName="PolicyNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClaimNo" msprop:Generator_ColumnVarNameInTable="columnClaimNo" msprop:Generator_ColumnPropNameInRow="ClaimNo" msprop:Generator_ColumnPropNameInTable="ClaimNoColumn" msprop:Generator_UserColumnName="ClaimNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateLose" msprop:Generator_ColumnVarNameInTable="columnDateLose" msprop:Generator_ColumnPropNameInRow="DateLose" msprop:Generator_ColumnPropNameInTable="DateLoseColumn" msprop:Generator_UserColumnName="DateLose" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DateReported" msprop:Generator_ColumnVarNameInTable="columnDateReported" msprop:Generator_ColumnPropNameInRow="DateReported" msprop:Generator_ColumnPropNameInTable="DateReportedColumn" msprop:Generator_UserColumnName="DateReported" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateClosed" msprop:Generator_ColumnVarNameInTable="columnDateClosed" msprop:Generator_ColumnPropNameInRow="DateClosed" msprop:Generator_ColumnPropNameInTable="DateClosedColumn" msprop:Generator_UserColumnName="DateClosed" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AmountPaid" msprop:Generator_ColumnVarNameInTable="columnAmountPaid" msprop:Generator_ColumnPropNameInRow="AmountPaid" msprop:Generator_ColumnPropNameInTable="AmountPaidColumn" msprop:Generator_UserColumnName="AmountPaid" type="xs:double" minOccurs="0" />
              <xs:element name="CheqNo" msprop:Generator_ColumnVarNameInTable="columnCheqNo" msprop:Generator_ColumnPropNameInRow="CheqNo" msprop:Generator_ColumnPropNameInTable="CheqNoColumn" msprop:Generator_UserColumnName="CheqNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransDate" msprop:Generator_ColumnVarNameInTable="columnTransDate" msprop:Generator_ColumnPropNameInRow="TransDate" msprop:Generator_ColumnPropNameInTable="TransDateColumn" msprop:Generator_UserColumnName="TransDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Claims" />
      <xs:field xpath="mstns:SNo" />
    </xs:unique>
  </xs:element>
</xs:schema>